<!DOCTYPE html>
<html>
 <head>
  <meta charset="UTF-8">
  <title>AlaSQL - JavaScript SQL database console</title>
  <link rel="stylesheet" href="style.css" type="text/css">

  <script src="xlsx.core.min.js"></script>
  <script src='alasql.min.js'></script>

 </head>
 <body>
  

<h1>AlaSQL - JavaScript SQL database console</h1>

<p>This is a demo console for AlaSQL javascript database. Read more information and documentation on 
<a href="https://github.com/agershun/alasql">https://github.com/agershun/alasql</a></p>


<p>Enter <b>SOURCE 'world.sql'</b> to load sample database, then <b>SHOW TABLES</b>, and then <b>SELECT TOP 10 * FROM City</b>. Then enter <b>SELECT VALUE COUNT(*) FROM TXT('world.sql') WHERE LEN([0])>20</b> to count number of lines with length more than 20 characters</p>

	 
	 
	 
	 
<div id='myconsole'></div>

	 
	 
<p>
	<tt><span id="useid">alasql</span> &gt;</tt> <input id='myprompt' autofocus/> 
</p>
	 
	 
	 <p><center><button onClick="showHelp()">Show list of commands</button></center></p>	 
	 
<script>
	var first = decodeURI(location.search.substr(1));
 	alasql.options.logtarget = 'myconsole';
	alasql.prompt('myprompt','useid');
	alasql.prompt('myprompt','useid', first);
	
	
	function showHelp(){
		alasql.log([
				{command:'ALTER TABLE table RENAME TO table'},
				{command:'ALTER TABLE table ADD COLUMN column coldef'},
				{command:'ALTER TABLE table MODIFY COLUMN column coldef'},
				{command:'ALTER TABLE table RENAME COLUMN column TO column'},
				{command:'ALTER TABLE table DROP column'},
				{command:'ATTACH engine DATABASE database'},
				{command:'ASSERT value'},
				{command:'CREATE [engine] DATABASE [IF NOT EXISTS] database'},
				{command:'CREATE TABLE [IF NOT EXISTS] table (column definitions)'},
				{command:'DELETE FROM table [WHERE expression]'},
				{command:'DETACH DATABASE database'},
				{command:'DROP [engine] DATABASE [IF EXISTS] database'},
				{command:'DROP TABLE [IF EXISTS] table'},
				{command:'INSERT INTO table VALUES value,...'},
				{command:'INSERT INTO table DEFAULT VALUES'},
				{command:'INSERT INTO table SELECT select'},
				{command:'SELECT [modificator] columns [INTO table] [FROM table,...] [[mode] JOIN [ON] [USING]] [WHERE ] [GROUP BY] [HAVING] [ORDER BY] '},
				{command:'SET option value'},
				{command:'SHOW [engine] DATABASES'},
				{command:'SHOW TABLES'},
				{command:'SHOW CREATE TABLE table'},
				{command:'UPDATE table SET column1 = expression1, ... [WHERE expression]'},
				{command:'USE [DATABASE] database'},
				{command:'See <a href="http://github/agershun/alasql">http://github/agershun/alasql</a> for more information'}
			])
	}
	
	
	
</script> 


</body>
</html>
